/*
*
* OrderDistributeExample.java
* @author yaokan
* @date 2021-01-08 18:00:48
*/
package com.steel.yfmall.cloud.assistant.po.oms;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderDistributeExample {
    /**
     * order_distribute
     */
    protected String orderByClause;

    /**
     * order_distribute
     */
    protected boolean distinct;

    /**
     * order_distribute
     */
    protected List<Criteria> oredCriteria;

    private Integer limit;

    private Integer offset;

    private String groupByClause;

    private String selectFields;

    /**
     * 构造查询条件:order_distribute
     * @Title: OrderDistributeExample
     * @Description: ( )
     * @return 返回类型 null
     * @date 2021-01-08 18:00:48
     */
    public OrderDistributeExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置排序字段:order_distribute
     * @Title: setOrderByClause
     * @Description: ( 设置排序字段 )
     * @param 参数说明 类型:String	名称:orderByClause 排序字段
     * @return 返回类型 null
     * @date 2021-01-08 18:00:48
     */
    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    /**
     * 获取排序字段:order_distribute
     * @Title: getOrderByClause
     * @Description: ( 获取排序字段 )
     * @return 返回类型 java.lang.String
     * @date 2021-01-08 18:00:48
     */
    public String getOrderByClause() {
        return orderByClause;
    }

    /**
     * 设置过滤重复数据:order_distribute
     * @Title: setDistinct
     * @Description: ( 设置过滤重复数据 )
     * @param 参数说明 类型:boolean	名称:distinct 是否过滤重复数据
     * @return 返回类型 null
     * @date 2021-01-08 18:00:48
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否过滤重复数据:order_distribute
     * @Title: isDistinct
     * @Description: ( 是否过滤重复数据 )
     * @return 返回类型 boolean
     * @date 2021-01-08 18:00:48
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获取当前的查询条件实例:order_distribute
     * @Title: getOredCriteria
     * @Description: ( 获取当前的查询条件实例 )
     * @return 返回类型 java.util.List<Criteria>
     * @date 2021-01-08 18:00:48
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     *:order_distribute
     * @Title: or
     * @Description: ( )
     *
     * @param 参数说明 类型:Criteria	名称:criteria 过滤条件实例
     * @return 返回类型 null
     * @date 2021-01-08 18:00:48
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     *:order_distribute
     * @Title: or
     * @Description: ( )
     *
     * @return 返回类型 Criteria
     * @date 2021-01-08 18:00:48
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建一个查询条件:order_distribute
     * @Title: createCriteria
     * @Description: ( 创建一个查询条件 )
     * @return 返回类型 Criteria
     * @date 2021-01-08 18:00:48
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 内部构建查询条件对象:order_distribute
     * @Title: createCriteriaInternal
     * @Description: ( 内部构建查询条件对象 )
     * @return 返回类型 Criteria
     * @date 2021-01-08 18:00:48
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除查询条件:order_distribute
     * @Title: clear
     * @Description: ( 清除查询条件 )
     * @return 返回类型 null
     * @date 2021-01-08 18:00:48
     */
    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    public void limit(Integer offset, Integer limit) {
        this.offset = offset;
        this.limit = limit;
    }

    public Integer getLimit() {
        return limit;
    }

    public void setOffset(Integer offset) {
        this.offset = offset;
    }

    public Integer getOffset() {
        return offset;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = groupByClause;
    }

    public String getGroupByClause() {
        return groupByClause;
    }

    public void setSelectFields(String selectFields) {
        this.selectFields = selectFields;
    }

    public String getSelectFields() {
        return selectFields;
    }

    /**
     * @title order_distribute表的实体类
     * @description order_distribute
     * @version 1.0
     * @author yaokan
     * @date 2021-01-08 18:00:48
     */
    protected abstract static class GeneratedCriteria implements java.io.Serializable {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrderSnIsNull() {
            addCriterion("order_sn is null");
            return (Criteria) this;
        }

        public Criteria andOrderSnIsNotNull() {
            addCriterion("order_sn is not null");
            return (Criteria) this;
        }

        public Criteria andOrderSnEqualTo(String value) {
            addCriterion("order_sn =", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnNotEqualTo(String value) {
            addCriterion("order_sn <>", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnGreaterThan(String value) {
            addCriterion("order_sn >", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnGreaterThanOrEqualTo(String value) {
            addCriterion("order_sn >=", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnLessThan(String value) {
            addCriterion("order_sn <", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnLessThanOrEqualTo(String value) {
            addCriterion("order_sn <=", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnLike(String value) {
            addCriterion("order_sn like", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnNotLike(String value) {
            addCriterion("order_sn not like", value, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnIn(List<String> values) {
            addCriterion("order_sn in", values, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnNotIn(List<String> values) {
            addCriterion("order_sn not in", values, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnBetween(String value1, String value2) {
            addCriterion("order_sn between", value1, value2, "orderSn");
            return (Criteria) this;
        }

        public Criteria andOrderSnNotBetween(String value1, String value2) {
            addCriterion("order_sn not between", value1, value2, "orderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnIsNull() {
            addCriterion("master_order_sn is null");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnIsNotNull() {
            addCriterion("master_order_sn is not null");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnEqualTo(String value) {
            addCriterion("master_order_sn =", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnNotEqualTo(String value) {
            addCriterion("master_order_sn <>", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnGreaterThan(String value) {
            addCriterion("master_order_sn >", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnGreaterThanOrEqualTo(String value) {
            addCriterion("master_order_sn >=", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnLessThan(String value) {
            addCriterion("master_order_sn <", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnLessThanOrEqualTo(String value) {
            addCriterion("master_order_sn <=", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnLike(String value) {
            addCriterion("master_order_sn like", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnNotLike(String value) {
            addCriterion("master_order_sn not like", value, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnIn(List<String> values) {
            addCriterion("master_order_sn in", values, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnNotIn(List<String> values) {
            addCriterion("master_order_sn not in", values, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnBetween(String value1, String value2) {
            addCriterion("master_order_sn between", value1, value2, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andMasterOrderSnNotBetween(String value1, String value2) {
            addCriterion("master_order_sn not between", value1, value2, "masterOrderSn");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNull() {
            addCriterion("order_type is null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIsNotNull() {
            addCriterion("order_type is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTypeEqualTo(Integer value) {
            addCriterion("order_type =", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotEqualTo(Integer value) {
            addCriterion("order_type <>", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThan(Integer value) {
            addCriterion("order_type >", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_type >=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThan(Integer value) {
            addCriterion("order_type <", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeLessThanOrEqualTo(Integer value) {
            addCriterion("order_type <=", value, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeIn(List<Integer> values) {
            addCriterion("order_type in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotIn(List<Integer> values) {
            addCriterion("order_type not in", values, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeBetween(Integer value1, Integer value2) {
            addCriterion("order_type between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andOrderTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("order_type not between", value1, value2, "orderType");
            return (Criteria) this;
        }

        public Criteria andTransTypeIsNull() {
            addCriterion("trans_type is null");
            return (Criteria) this;
        }

        public Criteria andTransTypeIsNotNull() {
            addCriterion("trans_type is not null");
            return (Criteria) this;
        }

        public Criteria andTransTypeEqualTo(Integer value) {
            addCriterion("trans_type =", value, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeNotEqualTo(Integer value) {
            addCriterion("trans_type <>", value, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeGreaterThan(Integer value) {
            addCriterion("trans_type >", value, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("trans_type >=", value, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeLessThan(Integer value) {
            addCriterion("trans_type <", value, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeLessThanOrEqualTo(Integer value) {
            addCriterion("trans_type <=", value, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeIn(List<Integer> values) {
            addCriterion("trans_type in", values, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeNotIn(List<Integer> values) {
            addCriterion("trans_type not in", values, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeBetween(Integer value1, Integer value2) {
            addCriterion("trans_type between", value1, value2, "transType");
            return (Criteria) this;
        }

        public Criteria andTransTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("trans_type not between", value1, value2, "transType");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnIsNull() {
            addCriterion("order_out_sn is null");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnIsNotNull() {
            addCriterion("order_out_sn is not null");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnEqualTo(String value) {
            addCriterion("order_out_sn =", value, "orderOutSn");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnNotEqualTo(String value) {
            addCriterion("order_out_sn <>", value, "orderOutSn");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnGreaterThan(String value) {
            addCriterion("order_out_sn >", value, "orderOutSn");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnGreaterThanOrEqualTo(String value) {
            addCriterion("order_out_sn >=", value, "orderOutSn");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnLessThan(String value) {
            addCriterion("order_out_sn <", value, "orderOutSn");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnLessThanOrEqualTo(String value) {
            addCriterion("order_out_sn <=", value, "orderOutSn");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnLike(String value) {
            addCriterion("order_out_sn like", value, "orderOutSn");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnNotLike(String value) {
            addCriterion("order_out_sn not like", value, "orderOutSn");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnIn(List<String> values) {
            addCriterion("order_out_sn in", values, "orderOutSn");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnNotIn(List<String> values) {
            addCriterion("order_out_sn not in", values, "orderOutSn");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnBetween(String value1, String value2) {
            addCriterion("order_out_sn between", value1, value2, "orderOutSn");
            return (Criteria) this;
        }

        public Criteria andOrderOutSnNotBetween(String value1, String value2) {
            addCriterion("order_out_sn not between", value1, value2, "orderOutSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnIsNull() {
            addCriterion("relating_original_sn is null");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnIsNotNull() {
            addCriterion("relating_original_sn is not null");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnEqualTo(String value) {
            addCriterion("relating_original_sn =", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnNotEqualTo(String value) {
            addCriterion("relating_original_sn <>", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnGreaterThan(String value) {
            addCriterion("relating_original_sn >", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnGreaterThanOrEqualTo(String value) {
            addCriterion("relating_original_sn >=", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnLessThan(String value) {
            addCriterion("relating_original_sn <", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnLessThanOrEqualTo(String value) {
            addCriterion("relating_original_sn <=", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnLike(String value) {
            addCriterion("relating_original_sn like", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnNotLike(String value) {
            addCriterion("relating_original_sn not like", value, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnIn(List<String> values) {
            addCriterion("relating_original_sn in", values, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnNotIn(List<String> values) {
            addCriterion("relating_original_sn not in", values, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnBetween(String value1, String value2) {
            addCriterion("relating_original_sn between", value1, value2, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingOriginalSnNotBetween(String value1, String value2) {
            addCriterion("relating_original_sn not between", value1, value2, "relatingOriginalSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnIsNull() {
            addCriterion("relating_return_sn is null");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnIsNotNull() {
            addCriterion("relating_return_sn is not null");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnEqualTo(String value) {
            addCriterion("relating_return_sn =", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnNotEqualTo(String value) {
            addCriterion("relating_return_sn <>", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnGreaterThan(String value) {
            addCriterion("relating_return_sn >", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnGreaterThanOrEqualTo(String value) {
            addCriterion("relating_return_sn >=", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnLessThan(String value) {
            addCriterion("relating_return_sn <", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnLessThanOrEqualTo(String value) {
            addCriterion("relating_return_sn <=", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnLike(String value) {
            addCriterion("relating_return_sn like", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnNotLike(String value) {
            addCriterion("relating_return_sn not like", value, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnIn(List<String> values) {
            addCriterion("relating_return_sn in", values, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnNotIn(List<String> values) {
            addCriterion("relating_return_sn not in", values, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnBetween(String value1, String value2) {
            addCriterion("relating_return_sn between", value1, value2, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingReturnSnNotBetween(String value1, String value2) {
            addCriterion("relating_return_sn not between", value1, value2, "relatingReturnSn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnIsNull() {
            addCriterion("relating_remoney_sn is null");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnIsNotNull() {
            addCriterion("relating_remoney_sn is not null");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnEqualTo(String value) {
            addCriterion("relating_remoney_sn =", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnNotEqualTo(String value) {
            addCriterion("relating_remoney_sn <>", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnGreaterThan(String value) {
            addCriterion("relating_remoney_sn >", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnGreaterThanOrEqualTo(String value) {
            addCriterion("relating_remoney_sn >=", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnLessThan(String value) {
            addCriterion("relating_remoney_sn <", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnLessThanOrEqualTo(String value) {
            addCriterion("relating_remoney_sn <=", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnLike(String value) {
            addCriterion("relating_remoney_sn like", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnNotLike(String value) {
            addCriterion("relating_remoney_sn not like", value, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnIn(List<String> values) {
            addCriterion("relating_remoney_sn in", values, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnNotIn(List<String> values) {
            addCriterion("relating_remoney_sn not in", values, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnBetween(String value1, String value2) {
            addCriterion("relating_remoney_sn between", value1, value2, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andRelatingRemoneySnNotBetween(String value1, String value2) {
            addCriterion("relating_remoney_sn not between", value1, value2, "relatingRemoneySn");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNull() {
            addCriterion("order_status is null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNotNull() {
            addCriterion("order_status is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusEqualTo(Integer value) {
            addCriterion("order_status =", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotEqualTo(Integer value) {
            addCriterion("order_status <>", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThan(Integer value) {
            addCriterion("order_status >", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_status >=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThan(Integer value) {
            addCriterion("order_status <", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThanOrEqualTo(Integer value) {
            addCriterion("order_status <=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIn(List<Integer> values) {
            addCriterion("order_status in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotIn(List<Integer> values) {
            addCriterion("order_status not in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusBetween(Integer value1, Integer value2) {
            addCriterion("order_status between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("order_status not between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusIsNull() {
            addCriterion("pay_status is null");
            return (Criteria) this;
        }

        public Criteria andPayStatusIsNotNull() {
            addCriterion("pay_status is not null");
            return (Criteria) this;
        }

        public Criteria andPayStatusEqualTo(Integer value) {
            addCriterion("pay_status =", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusNotEqualTo(Integer value) {
            addCriterion("pay_status <>", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusGreaterThan(Integer value) {
            addCriterion("pay_status >", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("pay_status >=", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusLessThan(Integer value) {
            addCriterion("pay_status <", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusLessThanOrEqualTo(Integer value) {
            addCriterion("pay_status <=", value, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusIn(List<Integer> values) {
            addCriterion("pay_status in", values, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusNotIn(List<Integer> values) {
            addCriterion("pay_status not in", values, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusBetween(Integer value1, Integer value2) {
            addCriterion("pay_status between", value1, value2, "payStatus");
            return (Criteria) this;
        }

        public Criteria andPayStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("pay_status not between", value1, value2, "payStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusIsNull() {
            addCriterion("ship_status is null");
            return (Criteria) this;
        }

        public Criteria andShipStatusIsNotNull() {
            addCriterion("ship_status is not null");
            return (Criteria) this;
        }

        public Criteria andShipStatusEqualTo(Integer value) {
            addCriterion("ship_status =", value, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusNotEqualTo(Integer value) {
            addCriterion("ship_status <>", value, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusGreaterThan(Integer value) {
            addCriterion("ship_status >", value, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("ship_status >=", value, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusLessThan(Integer value) {
            addCriterion("ship_status <", value, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusLessThanOrEqualTo(Integer value) {
            addCriterion("ship_status <=", value, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusIn(List<Integer> values) {
            addCriterion("ship_status in", values, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusNotIn(List<Integer> values) {
            addCriterion("ship_status not in", values, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusBetween(Integer value1, Integer value2) {
            addCriterion("ship_status between", value1, value2, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andShipStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("ship_status not between", value1, value2, "shipStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusIsNull() {
            addCriterion("question_status is null");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusIsNotNull() {
            addCriterion("question_status is not null");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusEqualTo(Integer value) {
            addCriterion("question_status =", value, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusNotEqualTo(Integer value) {
            addCriterion("question_status <>", value, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusGreaterThan(Integer value) {
            addCriterion("question_status >", value, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("question_status >=", value, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusLessThan(Integer value) {
            addCriterion("question_status <", value, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusLessThanOrEqualTo(Integer value) {
            addCriterion("question_status <=", value, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusIn(List<Integer> values) {
            addCriterion("question_status in", values, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusNotIn(List<Integer> values) {
            addCriterion("question_status not in", values, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusBetween(Integer value1, Integer value2) {
            addCriterion("question_status between", value1, value2, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andQuestionStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("question_status not between", value1, value2, "questionStatus");
            return (Criteria) this;
        }

        public Criteria andDepotStatusIsNull() {
            addCriterion("depot_status is null");
            return (Criteria) this;
        }

        public Criteria andDepotStatusIsNotNull() {
            addCriterion("depot_status is not null");
            return (Criteria) this;
        }

        public Criteria andDepotStatusEqualTo(Integer value) {
            addCriterion("depot_status =", value, "depotStatus");
            return (Criteria) this;
        }

        public Criteria andDepotStatusNotEqualTo(Integer value) {
            addCriterion("depot_status <>", value, "depotStatus");
            return (Criteria) this;
        }

        public Criteria andDepotStatusGreaterThan(Integer value) {
            addCriterion("depot_status >", value, "depotStatus");
            return (Criteria) this;
        }

        public Criteria andDepotStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("depot_status >=", value, "depotStatus");
            return (Criteria) this;
        }

        public Criteria andDepotStatusLessThan(Integer value) {
            addCriterion("depot_status <", value, "depotStatus");
            return (Criteria) this;
        }

        public Criteria andDepotStatusLessThanOrEqualTo(Integer value) {
            addCriterion("depot_status <=", value, "depotStatus");
            return (Criteria) this;
        }

        public Criteria andDepotStatusIn(List<Integer> values) {
            addCriterion("depot_status in", values, "depotStatus");
            return (Criteria) this;
        }

        public Criteria andDepotStatusNotIn(List<Integer> values) {
            addCriterion("depot_status not in", values, "depotStatus");
            return (Criteria) this;
        }

        public Criteria andDepotStatusBetween(Integer value1, Integer value2) {
            addCriterion("depot_status between", value1, value2, "depotStatus");
            return (Criteria) this;
        }

        public Criteria andDepotStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("depot_status not between", value1, value2, "depotStatus");
            return (Criteria) this;
        }

        public Criteria andOrderFromIsNull() {
            addCriterion("order_from is null");
            return (Criteria) this;
        }

        public Criteria andOrderFromIsNotNull() {
            addCriterion("order_from is not null");
            return (Criteria) this;
        }

        public Criteria andOrderFromEqualTo(String value) {
            addCriterion("order_from =", value, "orderFrom");
            return (Criteria) this;
        }

        public Criteria andOrderFromNotEqualTo(String value) {
            addCriterion("order_from <>", value, "orderFrom");
            return (Criteria) this;
        }

        public Criteria andOrderFromGreaterThan(String value) {
            addCriterion("order_from >", value, "orderFrom");
            return (Criteria) this;
        }

        public Criteria andOrderFromGreaterThanOrEqualTo(String value) {
            addCriterion("order_from >=", value, "orderFrom");
            return (Criteria) this;
        }

        public Criteria andOrderFromLessThan(String value) {
            addCriterion("order_from <", value, "orderFrom");
            return (Criteria) this;
        }

        public Criteria andOrderFromLessThanOrEqualTo(String value) {
            addCriterion("order_from <=", value, "orderFrom");
            return (Criteria) this;
        }

        public Criteria andOrderFromLike(String value) {
            addCriterion("order_from like", value, "orderFrom");
            return (Criteria) this;
        }

        public Criteria andOrderFromNotLike(String value) {
            addCriterion("order_from not like", value, "orderFrom");
            return (Criteria) this;
        }

        public Criteria andOrderFromIn(List<String> values) {
            addCriterion("order_from in", values, "orderFrom");
            return (Criteria) this;
        }

        public Criteria andOrderFromNotIn(List<String> values) {
            addCriterion("order_from not in", values, "orderFrom");
            return (Criteria) this;
        }

        public Criteria andOrderFromBetween(String value1, String value2) {
            addCriterion("order_from between", value1, value2, "orderFrom");
            return (Criteria) this;
        }

        public Criteria andOrderFromNotBetween(String value1, String value2) {
            addCriterion("order_from not between", value1, value2, "orderFrom");
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNull() {
            addCriterion("add_time is null");
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNotNull() {
            addCriterion("add_time is not null");
            return (Criteria) this;
        }

        public Criteria andAddTimeEqualTo(Date value) {
            addCriterion("add_time =", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotEqualTo(Date value) {
            addCriterion("add_time <>", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThan(Date value) {
            addCriterion("add_time >", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("add_time >=", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThan(Date value) {
            addCriterion("add_time <", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThanOrEqualTo(Date value) {
            addCriterion("add_time <=", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeIn(List<Date> values) {
            addCriterion("add_time in", values, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotIn(List<Date> values) {
            addCriterion("add_time not in", values, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeBetween(Date value1, Date value2) {
            addCriterion("add_time between", value1, value2, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotBetween(Date value1, Date value2) {
            addCriterion("add_time not between", value1, value2, "addTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeIsNull() {
            addCriterion("confirm_time is null");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeIsNotNull() {
            addCriterion("confirm_time is not null");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeEqualTo(Date value) {
            addCriterion("confirm_time =", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeNotEqualTo(Date value) {
            addCriterion("confirm_time <>", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeGreaterThan(Date value) {
            addCriterion("confirm_time >", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("confirm_time >=", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeLessThan(Date value) {
            addCriterion("confirm_time <", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeLessThanOrEqualTo(Date value) {
            addCriterion("confirm_time <=", value, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeIn(List<Date> values) {
            addCriterion("confirm_time in", values, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeNotIn(List<Date> values) {
            addCriterion("confirm_time not in", values, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeBetween(Date value1, Date value2) {
            addCriterion("confirm_time between", value1, value2, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andConfirmTimeNotBetween(Date value1, Date value2) {
            addCriterion("confirm_time not between", value1, value2, "confirmTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeIsNull() {
            addCriterion("signing_time is null");
            return (Criteria) this;
        }

        public Criteria andSigningTimeIsNotNull() {
            addCriterion("signing_time is not null");
            return (Criteria) this;
        }

        public Criteria andSigningTimeEqualTo(Date value) {
            addCriterion("signing_time =", value, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeNotEqualTo(Date value) {
            addCriterion("signing_time <>", value, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeGreaterThan(Date value) {
            addCriterion("signing_time >", value, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("signing_time >=", value, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeLessThan(Date value) {
            addCriterion("signing_time <", value, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeLessThanOrEqualTo(Date value) {
            addCriterion("signing_time <=", value, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeIn(List<Date> values) {
            addCriterion("signing_time in", values, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeNotIn(List<Date> values) {
            addCriterion("signing_time not in", values, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeBetween(Date value1, Date value2) {
            addCriterion("signing_time between", value1, value2, "signingTime");
            return (Criteria) this;
        }

        public Criteria andSigningTimeNotBetween(Date value1, Date value2) {
            addCriterion("signing_time not between", value1, value2, "signingTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNull() {
            addCriterion("finish_time is null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIsNotNull() {
            addCriterion("finish_time is not null");
            return (Criteria) this;
        }

        public Criteria andFinishTimeEqualTo(Date value) {
            addCriterion("finish_time =", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotEqualTo(Date value) {
            addCriterion("finish_time <>", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThan(Date value) {
            addCriterion("finish_time >", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("finish_time >=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThan(Date value) {
            addCriterion("finish_time <", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeLessThanOrEqualTo(Date value) {
            addCriterion("finish_time <=", value, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeIn(List<Date> values) {
            addCriterion("finish_time in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotIn(List<Date> values) {
            addCriterion("finish_time not in", values, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeBetween(Date value1, Date value2) {
            addCriterion("finish_time between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andFinishTimeNotBetween(Date value1, Date value2) {
            addCriterion("finish_time not between", value1, value2, "finishTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeIsNull() {
            addCriterion("clear_time is null");
            return (Criteria) this;
        }

        public Criteria andClearTimeIsNotNull() {
            addCriterion("clear_time is not null");
            return (Criteria) this;
        }

        public Criteria andClearTimeEqualTo(Date value) {
            addCriterion("clear_time =", value, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeNotEqualTo(Date value) {
            addCriterion("clear_time <>", value, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeGreaterThan(Date value) {
            addCriterion("clear_time >", value, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("clear_time >=", value, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeLessThan(Date value) {
            addCriterion("clear_time <", value, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeLessThanOrEqualTo(Date value) {
            addCriterion("clear_time <=", value, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeIn(List<Date> values) {
            addCriterion("clear_time in", values, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeNotIn(List<Date> values) {
            addCriterion("clear_time not in", values, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeBetween(Date value1, Date value2) {
            addCriterion("clear_time between", value1, value2, "clearTime");
            return (Criteria) this;
        }

        public Criteria andClearTimeNotBetween(Date value1, Date value2) {
            addCriterion("clear_time not between", value1, value2, "clearTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeIsNull() {
            addCriterion("question_time is null");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeIsNotNull() {
            addCriterion("question_time is not null");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeEqualTo(Date value) {
            addCriterion("question_time =", value, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeNotEqualTo(Date value) {
            addCriterion("question_time <>", value, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeGreaterThan(Date value) {
            addCriterion("question_time >", value, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("question_time >=", value, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeLessThan(Date value) {
            addCriterion("question_time <", value, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeLessThanOrEqualTo(Date value) {
            addCriterion("question_time <=", value, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeIn(List<Date> values) {
            addCriterion("question_time in", values, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeNotIn(List<Date> values) {
            addCriterion("question_time not in", values, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeBetween(Date value1, Date value2) {
            addCriterion("question_time between", value1, value2, "questionTime");
            return (Criteria) this;
        }

        public Criteria andQuestionTimeNotBetween(Date value1, Date value2) {
            addCriterion("question_time not between", value1, value2, "questionTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andRefererIsNull() {
            addCriterion("referer is null");
            return (Criteria) this;
        }

        public Criteria andRefererIsNotNull() {
            addCriterion("referer is not null");
            return (Criteria) this;
        }

        public Criteria andRefererEqualTo(String value) {
            addCriterion("referer =", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererNotEqualTo(String value) {
            addCriterion("referer <>", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererGreaterThan(String value) {
            addCriterion("referer >", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererGreaterThanOrEqualTo(String value) {
            addCriterion("referer >=", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererLessThan(String value) {
            addCriterion("referer <", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererLessThanOrEqualTo(String value) {
            addCriterion("referer <=", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererLike(String value) {
            addCriterion("referer like", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererNotLike(String value) {
            addCriterion("referer not like", value, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererIn(List<String> values) {
            addCriterion("referer in", values, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererNotIn(List<String> values) {
            addCriterion("referer not in", values, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererBetween(String value1, String value2) {
            addCriterion("referer between", value1, value2, "referer");
            return (Criteria) this;
        }

        public Criteria andRefererNotBetween(String value1, String value2) {
            addCriterion("referer not between", value1, value2, "referer");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeIsNull() {
            addCriterion("shipping_total_fee is null");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeIsNotNull() {
            addCriterion("shipping_total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeEqualTo(BigDecimal value) {
            addCriterion("shipping_total_fee =", value, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeNotEqualTo(BigDecimal value) {
            addCriterion("shipping_total_fee <>", value, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeGreaterThan(BigDecimal value) {
            addCriterion("shipping_total_fee >", value, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping_total_fee >=", value, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeLessThan(BigDecimal value) {
            addCriterion("shipping_total_fee <", value, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("shipping_total_fee <=", value, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeIn(List<BigDecimal> values) {
            addCriterion("shipping_total_fee in", values, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeNotIn(List<BigDecimal> values) {
            addCriterion("shipping_total_fee not in", values, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping_total_fee between", value1, value2, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andShippingTotalFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("shipping_total_fee not between", value1, value2, "shippingTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeIsNull() {
            addCriterion("pay_total_fee is null");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeIsNotNull() {
            addCriterion("pay_total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeEqualTo(BigDecimal value) {
            addCriterion("pay_total_fee =", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeNotEqualTo(BigDecimal value) {
            addCriterion("pay_total_fee <>", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeGreaterThan(BigDecimal value) {
            addCriterion("pay_total_fee >", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_total_fee >=", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeLessThan(BigDecimal value) {
            addCriterion("pay_total_fee <", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("pay_total_fee <=", value, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeIn(List<BigDecimal> values) {
            addCriterion("pay_total_fee in", values, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeNotIn(List<BigDecimal> values) {
            addCriterion("pay_total_fee not in", values, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_total_fee between", value1, value2, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andPayTotalFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("pay_total_fee not between", value1, value2, "payTotalFee");
            return (Criteria) this;
        }

        public Criteria andTotalPayableIsNull() {
            addCriterion("total_payable is null");
            return (Criteria) this;
        }

        public Criteria andTotalPayableIsNotNull() {
            addCriterion("total_payable is not null");
            return (Criteria) this;
        }

        public Criteria andTotalPayableEqualTo(BigDecimal value) {
            addCriterion("total_payable =", value, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableNotEqualTo(BigDecimal value) {
            addCriterion("total_payable <>", value, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableGreaterThan(BigDecimal value) {
            addCriterion("total_payable >", value, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("total_payable >=", value, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableLessThan(BigDecimal value) {
            addCriterion("total_payable <", value, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableLessThanOrEqualTo(BigDecimal value) {
            addCriterion("total_payable <=", value, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableIn(List<BigDecimal> values) {
            addCriterion("total_payable in", values, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableNotIn(List<BigDecimal> values) {
            addCriterion("total_payable not in", values, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_payable between", value1, value2, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andTotalPayableNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_payable not between", value1, value2, "totalPayable");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountIsNull() {
            addCriterion("goods_amount is null");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountIsNotNull() {
            addCriterion("goods_amount is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountEqualTo(BigDecimal value) {
            addCriterion("goods_amount =", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountNotEqualTo(BigDecimal value) {
            addCriterion("goods_amount <>", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountGreaterThan(BigDecimal value) {
            addCriterion("goods_amount >", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_amount >=", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountLessThan(BigDecimal value) {
            addCriterion("goods_amount <", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("goods_amount <=", value, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountIn(List<BigDecimal> values) {
            addCriterion("goods_amount in", values, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountNotIn(List<BigDecimal> values) {
            addCriterion("goods_amount not in", values, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_amount between", value1, value2, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andGoodsAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("goods_amount not between", value1, value2, "goodsAmount");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIsNull() {
            addCriterion("total_fee is null");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIsNotNull() {
            addCriterion("total_fee is not null");
            return (Criteria) this;
        }

        public Criteria andTotalFeeEqualTo(BigDecimal value) {
            addCriterion("total_fee =", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotEqualTo(BigDecimal value) {
            addCriterion("total_fee <>", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeGreaterThan(BigDecimal value) {
            addCriterion("total_fee >", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("total_fee >=", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeLessThan(BigDecimal value) {
            addCriterion("total_fee <", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("total_fee <=", value, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeIn(List<BigDecimal> values) {
            addCriterion("total_fee in", values, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotIn(List<BigDecimal> values) {
            addCriterion("total_fee not in", values, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_fee between", value1, value2, "totalFee");
            return (Criteria) this;
        }

        public Criteria andTotalFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_fee not between", value1, value2, "totalFee");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidIsNull() {
            addCriterion("money_paid is null");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidIsNotNull() {
            addCriterion("money_paid is not null");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidEqualTo(BigDecimal value) {
            addCriterion("money_paid =", value, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidNotEqualTo(BigDecimal value) {
            addCriterion("money_paid <>", value, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidGreaterThan(BigDecimal value) {
            addCriterion("money_paid >", value, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("money_paid >=", value, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidLessThan(BigDecimal value) {
            addCriterion("money_paid <", value, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidLessThanOrEqualTo(BigDecimal value) {
            addCriterion("money_paid <=", value, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidIn(List<BigDecimal> values) {
            addCriterion("money_paid in", values, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidNotIn(List<BigDecimal> values) {
            addCriterion("money_paid not in", values, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("money_paid between", value1, value2, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andMoneyPaidNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("money_paid not between", value1, value2, "moneyPaid");
            return (Criteria) this;
        }

        public Criteria andSurplusIsNull() {
            addCriterion("surplus is null");
            return (Criteria) this;
        }

        public Criteria andSurplusIsNotNull() {
            addCriterion("surplus is not null");
            return (Criteria) this;
        }

        public Criteria andSurplusEqualTo(BigDecimal value) {
            addCriterion("surplus =", value, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusNotEqualTo(BigDecimal value) {
            addCriterion("surplus <>", value, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusGreaterThan(BigDecimal value) {
            addCriterion("surplus >", value, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("surplus >=", value, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusLessThan(BigDecimal value) {
            addCriterion("surplus <", value, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusLessThanOrEqualTo(BigDecimal value) {
            addCriterion("surplus <=", value, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusIn(List<BigDecimal> values) {
            addCriterion("surplus in", values, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusNotIn(List<BigDecimal> values) {
            addCriterion("surplus not in", values, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("surplus between", value1, value2, "surplus");
            return (Criteria) this;
        }

        public Criteria andSurplusNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("surplus not between", value1, value2, "surplus");
            return (Criteria) this;
        }

        public Criteria andBonusIsNull() {
            addCriterion("bonus is null");
            return (Criteria) this;
        }

        public Criteria andBonusIsNotNull() {
            addCriterion("bonus is not null");
            return (Criteria) this;
        }

        public Criteria andBonusEqualTo(BigDecimal value) {
            addCriterion("bonus =", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusNotEqualTo(BigDecimal value) {
            addCriterion("bonus <>", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusGreaterThan(BigDecimal value) {
            addCriterion("bonus >", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("bonus >=", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusLessThan(BigDecimal value) {
            addCriterion("bonus <", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusLessThanOrEqualTo(BigDecimal value) {
            addCriterion("bonus <=", value, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusIn(List<BigDecimal> values) {
            addCriterion("bonus in", values, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusNotIn(List<BigDecimal> values) {
            addCriterion("bonus not in", values, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("bonus between", value1, value2, "bonus");
            return (Criteria) this;
        }

        public Criteria andBonusNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("bonus not between", value1, value2, "bonus");
            return (Criteria) this;
        }

        public Criteria andGoodsCountIsNull() {
            addCriterion("goods_count is null");
            return (Criteria) this;
        }

        public Criteria andGoodsCountIsNotNull() {
            addCriterion("goods_count is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsCountEqualTo(Integer value) {
            addCriterion("goods_count =", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountNotEqualTo(Integer value) {
            addCriterion("goods_count <>", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountGreaterThan(Integer value) {
            addCriterion("goods_count >", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountGreaterThanOrEqualTo(Integer value) {
            addCriterion("goods_count >=", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountLessThan(Integer value) {
            addCriterion("goods_count <", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountLessThanOrEqualTo(Integer value) {
            addCriterion("goods_count <=", value, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountIn(List<Integer> values) {
            addCriterion("goods_count in", values, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountNotIn(List<Integer> values) {
            addCriterion("goods_count not in", values, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountBetween(Integer value1, Integer value2) {
            addCriterion("goods_count between", value1, value2, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andGoodsCountNotBetween(Integer value1, Integer value2) {
            addCriterion("goods_count not between", value1, value2, "goodsCount");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNull() {
            addCriterion("discount is null");
            return (Criteria) this;
        }

        public Criteria andDiscountIsNotNull() {
            addCriterion("discount is not null");
            return (Criteria) this;
        }

        public Criteria andDiscountEqualTo(BigDecimal value) {
            addCriterion("discount =", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotEqualTo(BigDecimal value) {
            addCriterion("discount <>", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThan(BigDecimal value) {
            addCriterion("discount >", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("discount >=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThan(BigDecimal value) {
            addCriterion("discount <", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("discount <=", value, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountIn(List<BigDecimal> values) {
            addCriterion("discount in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotIn(List<BigDecimal> values) {
            addCriterion("discount not in", values, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andDiscountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("discount not between", value1, value2, "discount");
            return (Criteria) this;
        }

        public Criteria andLastUpdateTimeIsNull() {
            addCriterion("last_update_time is null");
            return (Criteria) this;
        }

        public Criteria andLastUpdateTimeIsNotNull() {
            addCriterion("last_update_time is not null");
            return (Criteria) this;
        }

        public Criteria andLastUpdateTimeEqualTo(Date value) {
            addCriterion("last_update_time =", value, "lastUpdateTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdateTimeNotEqualTo(Date value) {
            addCriterion("last_update_time <>", value, "lastUpdateTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdateTimeGreaterThan(Date value) {
            addCriterion("last_update_time >", value, "lastUpdateTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("last_update_time >=", value, "lastUpdateTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdateTimeLessThan(Date value) {
            addCriterion("last_update_time <", value, "lastUpdateTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("last_update_time <=", value, "lastUpdateTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdateTimeIn(List<Date> values) {
            addCriterion("last_update_time in", values, "lastUpdateTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdateTimeNotIn(List<Date> values) {
            addCriterion("last_update_time not in", values, "lastUpdateTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("last_update_time between", value1, value2, "lastUpdateTime");
            return (Criteria) this;
        }

        public Criteria andLastUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("last_update_time not between", value1, value2, "lastUpdateTime");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyIsNull() {
            addCriterion("integral_money is null");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyIsNotNull() {
            addCriterion("integral_money is not null");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyEqualTo(BigDecimal value) {
            addCriterion("integral_money =", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyNotEqualTo(BigDecimal value) {
            addCriterion("integral_money <>", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyGreaterThan(BigDecimal value) {
            addCriterion("integral_money >", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("integral_money >=", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyLessThan(BigDecimal value) {
            addCriterion("integral_money <", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyLessThanOrEqualTo(BigDecimal value) {
            addCriterion("integral_money <=", value, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyIn(List<BigDecimal> values) {
            addCriterion("integral_money in", values, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyNotIn(List<BigDecimal> values) {
            addCriterion("integral_money not in", values, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("integral_money between", value1, value2, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralMoneyNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("integral_money not between", value1, value2, "integralMoney");
            return (Criteria) this;
        }

        public Criteria andIntegralIsNull() {
            addCriterion("integral is null");
            return (Criteria) this;
        }

        public Criteria andIntegralIsNotNull() {
            addCriterion("integral is not null");
            return (Criteria) this;
        }

        public Criteria andIntegralEqualTo(Integer value) {
            addCriterion("integral =", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralNotEqualTo(Integer value) {
            addCriterion("integral <>", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralGreaterThan(Integer value) {
            addCriterion("integral >", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralGreaterThanOrEqualTo(Integer value) {
            addCriterion("integral >=", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralLessThan(Integer value) {
            addCriterion("integral <", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralLessThanOrEqualTo(Integer value) {
            addCriterion("integral <=", value, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralIn(List<Integer> values) {
            addCriterion("integral in", values, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralNotIn(List<Integer> values) {
            addCriterion("integral not in", values, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralBetween(Integer value1, Integer value2) {
            addCriterion("integral between", value1, value2, "integral");
            return (Criteria) this;
        }

        public Criteria andIntegralNotBetween(Integer value1, Integer value2) {
            addCriterion("integral not between", value1, value2, "integral");
            return (Criteria) this;
        }

        public Criteria andCancelCodeIsNull() {
            addCriterion("cancel_code is null");
            return (Criteria) this;
        }

        public Criteria andCancelCodeIsNotNull() {
            addCriterion("cancel_code is not null");
            return (Criteria) this;
        }

        public Criteria andCancelCodeEqualTo(String value) {
            addCriterion("cancel_code =", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeNotEqualTo(String value) {
            addCriterion("cancel_code <>", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeGreaterThan(String value) {
            addCriterion("cancel_code >", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeGreaterThanOrEqualTo(String value) {
            addCriterion("cancel_code >=", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeLessThan(String value) {
            addCriterion("cancel_code <", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeLessThanOrEqualTo(String value) {
            addCriterion("cancel_code <=", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeLike(String value) {
            addCriterion("cancel_code like", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeNotLike(String value) {
            addCriterion("cancel_code not like", value, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeIn(List<String> values) {
            addCriterion("cancel_code in", values, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeNotIn(List<String> values) {
            addCriterion("cancel_code not in", values, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeBetween(String value1, String value2) {
            addCriterion("cancel_code between", value1, value2, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelCodeNotBetween(String value1, String value2) {
            addCriterion("cancel_code not between", value1, value2, "cancelCode");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIsNull() {
            addCriterion("cancel_reason is null");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIsNotNull() {
            addCriterion("cancel_reason is not null");
            return (Criteria) this;
        }

        public Criteria andCancelReasonEqualTo(String value) {
            addCriterion("cancel_reason =", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotEqualTo(String value) {
            addCriterion("cancel_reason <>", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonGreaterThan(String value) {
            addCriterion("cancel_reason >", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonGreaterThanOrEqualTo(String value) {
            addCriterion("cancel_reason >=", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonLessThan(String value) {
            addCriterion("cancel_reason <", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonLessThanOrEqualTo(String value) {
            addCriterion("cancel_reason <=", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonLike(String value) {
            addCriterion("cancel_reason like", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotLike(String value) {
            addCriterion("cancel_reason not like", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIn(List<String> values) {
            addCriterion("cancel_reason in", values, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotIn(List<String> values) {
            addCriterion("cancel_reason not in", values, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonBetween(String value1, String value2) {
            addCriterion("cancel_reason between", value1, value2, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotBetween(String value1, String value2) {
            addCriterion("cancel_reason not between", value1, value2, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andIsnowIsNull() {
            addCriterion("isNow is null");
            return (Criteria) this;
        }

        public Criteria andIsnowIsNotNull() {
            addCriterion("isNow is not null");
            return (Criteria) this;
        }

        public Criteria andIsnowEqualTo(Integer value) {
            addCriterion("isNow =", value, "isnow");
            return (Criteria) this;
        }

        public Criteria andIsnowNotEqualTo(Integer value) {
            addCriterion("isNow <>", value, "isnow");
            return (Criteria) this;
        }

        public Criteria andIsnowGreaterThan(Integer value) {
            addCriterion("isNow >", value, "isnow");
            return (Criteria) this;
        }

        public Criteria andIsnowGreaterThanOrEqualTo(Integer value) {
            addCriterion("isNow >=", value, "isnow");
            return (Criteria) this;
        }

        public Criteria andIsnowLessThan(Integer value) {
            addCriterion("isNow <", value, "isnow");
            return (Criteria) this;
        }

        public Criteria andIsnowLessThanOrEqualTo(Integer value) {
            addCriterion("isNow <=", value, "isnow");
            return (Criteria) this;
        }

        public Criteria andIsnowIn(List<Integer> values) {
            addCriterion("isNow in", values, "isnow");
            return (Criteria) this;
        }

        public Criteria andIsnowNotIn(List<Integer> values) {
            addCriterion("isNow not in", values, "isnow");
            return (Criteria) this;
        }

        public Criteria andIsnowBetween(Integer value1, Integer value2) {
            addCriterion("isNow between", value1, value2, "isnow");
            return (Criteria) this;
        }

        public Criteria andIsnowNotBetween(Integer value1, Integer value2) {
            addCriterion("isNow not between", value1, value2, "isnow");
            return (Criteria) this;
        }

        public Criteria andSourceIsNull() {
            addCriterion("source is null");
            return (Criteria) this;
        }

        public Criteria andSourceIsNotNull() {
            addCriterion("source is not null");
            return (Criteria) this;
        }

        public Criteria andSourceEqualTo(Integer value) {
            addCriterion("source =", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotEqualTo(Integer value) {
            addCriterion("source <>", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThan(Integer value) {
            addCriterion("source >", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceGreaterThanOrEqualTo(Integer value) {
            addCriterion("source >=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThan(Integer value) {
            addCriterion("source <", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceLessThanOrEqualTo(Integer value) {
            addCriterion("source <=", value, "source");
            return (Criteria) this;
        }

        public Criteria andSourceIn(List<Integer> values) {
            addCriterion("source in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotIn(List<Integer> values) {
            addCriterion("source not in", values, "source");
            return (Criteria) this;
        }

        public Criteria andSourceBetween(Integer value1, Integer value2) {
            addCriterion("source between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSourceNotBetween(Integer value1, Integer value2) {
            addCriterion("source not between", value1, value2, "source");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeIsNull() {
            addCriterion("supplier_code is null");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeIsNotNull() {
            addCriterion("supplier_code is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeEqualTo(String value) {
            addCriterion("supplier_code =", value, "supplierCode");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeNotEqualTo(String value) {
            addCriterion("supplier_code <>", value, "supplierCode");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeGreaterThan(String value) {
            addCriterion("supplier_code >", value, "supplierCode");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeGreaterThanOrEqualTo(String value) {
            addCriterion("supplier_code >=", value, "supplierCode");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeLessThan(String value) {
            addCriterion("supplier_code <", value, "supplierCode");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeLessThanOrEqualTo(String value) {
            addCriterion("supplier_code <=", value, "supplierCode");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeLike(String value) {
            addCriterion("supplier_code like", value, "supplierCode");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeNotLike(String value) {
            addCriterion("supplier_code not like", value, "supplierCode");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeIn(List<String> values) {
            addCriterion("supplier_code in", values, "supplierCode");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeNotIn(List<String> values) {
            addCriterion("supplier_code not in", values, "supplierCode");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeBetween(String value1, String value2) {
            addCriterion("supplier_code between", value1, value2, "supplierCode");
            return (Criteria) this;
        }

        public Criteria andSupplierCodeNotBetween(String value1, String value2) {
            addCriterion("supplier_code not between", value1, value2, "supplierCode");
            return (Criteria) this;
        }

        public Criteria andSupplierNameIsNull() {
            addCriterion("supplier_name is null");
            return (Criteria) this;
        }

        public Criteria andSupplierNameIsNotNull() {
            addCriterion("supplier_name is not null");
            return (Criteria) this;
        }

        public Criteria andSupplierNameEqualTo(String value) {
            addCriterion("supplier_name =", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotEqualTo(String value) {
            addCriterion("supplier_name <>", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameGreaterThan(String value) {
            addCriterion("supplier_name >", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameGreaterThanOrEqualTo(String value) {
            addCriterion("supplier_name >=", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameLessThan(String value) {
            addCriterion("supplier_name <", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameLessThanOrEqualTo(String value) {
            addCriterion("supplier_name <=", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameLike(String value) {
            addCriterion("supplier_name like", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotLike(String value) {
            addCriterion("supplier_name not like", value, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameIn(List<String> values) {
            addCriterion("supplier_name in", values, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotIn(List<String> values) {
            addCriterion("supplier_name not in", values, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameBetween(String value1, String value2) {
            addCriterion("supplier_name between", value1, value2, "supplierName");
            return (Criteria) this;
        }

        public Criteria andSupplierNameNotBetween(String value1, String value2) {
            addCriterion("supplier_name not between", value1, value2, "supplierName");
            return (Criteria) this;
        }

        public Criteria andIsDelIsNull() {
            addCriterion("is_del is null");
            return (Criteria) this;
        }

        public Criteria andIsDelIsNotNull() {
            addCriterion("is_del is not null");
            return (Criteria) this;
        }

        public Criteria andIsDelEqualTo(Integer value) {
            addCriterion("is_del =", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotEqualTo(Integer value) {
            addCriterion("is_del <>", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelGreaterThan(Integer value) {
            addCriterion("is_del >", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelGreaterThanOrEqualTo(Integer value) {
            addCriterion("is_del >=", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelLessThan(Integer value) {
            addCriterion("is_del <", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelLessThanOrEqualTo(Integer value) {
            addCriterion("is_del <=", value, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelIn(List<Integer> values) {
            addCriterion("is_del in", values, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotIn(List<Integer> values) {
            addCriterion("is_del not in", values, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelBetween(Integer value1, Integer value2) {
            addCriterion("is_del between", value1, value2, "isDel");
            return (Criteria) this;
        }

        public Criteria andIsDelNotBetween(Integer value1, Integer value2) {
            addCriterion("is_del not between", value1, value2, "isDel");
            return (Criteria) this;
        }

        public Criteria andResendErpIsNull() {
            addCriterion("resend_erp is null");
            return (Criteria) this;
        }

        public Criteria andResendErpIsNotNull() {
            addCriterion("resend_erp is not null");
            return (Criteria) this;
        }

        public Criteria andResendErpEqualTo(Integer value) {
            addCriterion("resend_erp =", value, "resendErp");
            return (Criteria) this;
        }

        public Criteria andResendErpNotEqualTo(Integer value) {
            addCriterion("resend_erp <>", value, "resendErp");
            return (Criteria) this;
        }

        public Criteria andResendErpGreaterThan(Integer value) {
            addCriterion("resend_erp >", value, "resendErp");
            return (Criteria) this;
        }

        public Criteria andResendErpGreaterThanOrEqualTo(Integer value) {
            addCriterion("resend_erp >=", value, "resendErp");
            return (Criteria) this;
        }

        public Criteria andResendErpLessThan(Integer value) {
            addCriterion("resend_erp <", value, "resendErp");
            return (Criteria) this;
        }

        public Criteria andResendErpLessThanOrEqualTo(Integer value) {
            addCriterion("resend_erp <=", value, "resendErp");
            return (Criteria) this;
        }

        public Criteria andResendErpIn(List<Integer> values) {
            addCriterion("resend_erp in", values, "resendErp");
            return (Criteria) this;
        }

        public Criteria andResendErpNotIn(List<Integer> values) {
            addCriterion("resend_erp not in", values, "resendErp");
            return (Criteria) this;
        }

        public Criteria andResendErpBetween(Integer value1, Integer value2) {
            addCriterion("resend_erp between", value1, value2, "resendErp");
            return (Criteria) this;
        }

        public Criteria andResendErpNotBetween(Integer value1, Integer value2) {
            addCriterion("resend_erp not between", value1, value2, "resendErp");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesIsNull() {
            addCriterion("question_codes is null");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesIsNotNull() {
            addCriterion("question_codes is not null");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesEqualTo(String value) {
            addCriterion("question_codes =", value, "questionCodes");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesNotEqualTo(String value) {
            addCriterion("question_codes <>", value, "questionCodes");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesGreaterThan(String value) {
            addCriterion("question_codes >", value, "questionCodes");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesGreaterThanOrEqualTo(String value) {
            addCriterion("question_codes >=", value, "questionCodes");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesLessThan(String value) {
            addCriterion("question_codes <", value, "questionCodes");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesLessThanOrEqualTo(String value) {
            addCriterion("question_codes <=", value, "questionCodes");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesLike(String value) {
            addCriterion("question_codes like", value, "questionCodes");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesNotLike(String value) {
            addCriterion("question_codes not like", value, "questionCodes");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesIn(List<String> values) {
            addCriterion("question_codes in", values, "questionCodes");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesNotIn(List<String> values) {
            addCriterion("question_codes not in", values, "questionCodes");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesBetween(String value1, String value2) {
            addCriterion("question_codes between", value1, value2, "questionCodes");
            return (Criteria) this;
        }

        public Criteria andQuestionCodesNotBetween(String value1, String value2) {
            addCriterion("question_codes not between", value1, value2, "questionCodes");
            return (Criteria) this;
        }

        public Criteria andPayInfoIsNull() {
            addCriterion("pay_info is null");
            return (Criteria) this;
        }

        public Criteria andPayInfoIsNotNull() {
            addCriterion("pay_info is not null");
            return (Criteria) this;
        }

        public Criteria andPayInfoEqualTo(String value) {
            addCriterion("pay_info =", value, "payInfo");
            return (Criteria) this;
        }

        public Criteria andPayInfoNotEqualTo(String value) {
            addCriterion("pay_info <>", value, "payInfo");
            return (Criteria) this;
        }

        public Criteria andPayInfoGreaterThan(String value) {
            addCriterion("pay_info >", value, "payInfo");
            return (Criteria) this;
        }

        public Criteria andPayInfoGreaterThanOrEqualTo(String value) {
            addCriterion("pay_info >=", value, "payInfo");
            return (Criteria) this;
        }

        public Criteria andPayInfoLessThan(String value) {
            addCriterion("pay_info <", value, "payInfo");
            return (Criteria) this;
        }

        public Criteria andPayInfoLessThanOrEqualTo(String value) {
            addCriterion("pay_info <=", value, "payInfo");
            return (Criteria) this;
        }

        public Criteria andPayInfoLike(String value) {
            addCriterion("pay_info like", value, "payInfo");
            return (Criteria) this;
        }

        public Criteria andPayInfoNotLike(String value) {
            addCriterion("pay_info not like", value, "payInfo");
            return (Criteria) this;
        }

        public Criteria andPayInfoIn(List<String> values) {
            addCriterion("pay_info in", values, "payInfo");
            return (Criteria) this;
        }

        public Criteria andPayInfoNotIn(List<String> values) {
            addCriterion("pay_info not in", values, "payInfo");
            return (Criteria) this;
        }

        public Criteria andPayInfoBetween(String value1, String value2) {
            addCriterion("pay_info between", value1, value2, "payInfo");
            return (Criteria) this;
        }

        public Criteria andPayInfoNotBetween(String value1, String value2) {
            addCriterion("pay_info not between", value1, value2, "payInfo");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameIsNull() {
            addCriterion("vendee_agent_name is null");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameIsNotNull() {
            addCriterion("vendee_agent_name is not null");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameEqualTo(String value) {
            addCriterion("vendee_agent_name =", value, "vendeeAgentName");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameNotEqualTo(String value) {
            addCriterion("vendee_agent_name <>", value, "vendeeAgentName");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameGreaterThan(String value) {
            addCriterion("vendee_agent_name >", value, "vendeeAgentName");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameGreaterThanOrEqualTo(String value) {
            addCriterion("vendee_agent_name >=", value, "vendeeAgentName");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameLessThan(String value) {
            addCriterion("vendee_agent_name <", value, "vendeeAgentName");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameLessThanOrEqualTo(String value) {
            addCriterion("vendee_agent_name <=", value, "vendeeAgentName");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameLike(String value) {
            addCriterion("vendee_agent_name like", value, "vendeeAgentName");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameNotLike(String value) {
            addCriterion("vendee_agent_name not like", value, "vendeeAgentName");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameIn(List<String> values) {
            addCriterion("vendee_agent_name in", values, "vendeeAgentName");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameNotIn(List<String> values) {
            addCriterion("vendee_agent_name not in", values, "vendeeAgentName");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameBetween(String value1, String value2) {
            addCriterion("vendee_agent_name between", value1, value2, "vendeeAgentName");
            return (Criteria) this;
        }

        public Criteria andVendeeAgentNameNotBetween(String value1, String value2) {
            addCriterion("vendee_agent_name not between", value1, value2, "vendeeAgentName");
            return (Criteria) this;
        }

        public Criteria andGotCodeIsNull() {
            addCriterion("got_code is null");
            return (Criteria) this;
        }

        public Criteria andGotCodeIsNotNull() {
            addCriterion("got_code is not null");
            return (Criteria) this;
        }

        public Criteria andGotCodeEqualTo(String value) {
            addCriterion("got_code =", value, "gotCode");
            return (Criteria) this;
        }

        public Criteria andGotCodeNotEqualTo(String value) {
            addCriterion("got_code <>", value, "gotCode");
            return (Criteria) this;
        }

        public Criteria andGotCodeGreaterThan(String value) {
            addCriterion("got_code >", value, "gotCode");
            return (Criteria) this;
        }

        public Criteria andGotCodeGreaterThanOrEqualTo(String value) {
            addCriterion("got_code >=", value, "gotCode");
            return (Criteria) this;
        }

        public Criteria andGotCodeLessThan(String value) {
            addCriterion("got_code <", value, "gotCode");
            return (Criteria) this;
        }

        public Criteria andGotCodeLessThanOrEqualTo(String value) {
            addCriterion("got_code <=", value, "gotCode");
            return (Criteria) this;
        }

        public Criteria andGotCodeLike(String value) {
            addCriterion("got_code like", value, "gotCode");
            return (Criteria) this;
        }

        public Criteria andGotCodeNotLike(String value) {
            addCriterion("got_code not like", value, "gotCode");
            return (Criteria) this;
        }

        public Criteria andGotCodeIn(List<String> values) {
            addCriterion("got_code in", values, "gotCode");
            return (Criteria) this;
        }

        public Criteria andGotCodeNotIn(List<String> values) {
            addCriterion("got_code not in", values, "gotCode");
            return (Criteria) this;
        }

        public Criteria andGotCodeBetween(String value1, String value2) {
            addCriterion("got_code between", value1, value2, "gotCode");
            return (Criteria) this;
        }

        public Criteria andGotCodeNotBetween(String value1, String value2) {
            addCriterion("got_code not between", value1, value2, "gotCode");
            return (Criteria) this;
        }

        public Criteria andGotStatusIsNull() {
            addCriterion("got_status is null");
            return (Criteria) this;
        }

        public Criteria andGotStatusIsNotNull() {
            addCriterion("got_status is not null");
            return (Criteria) this;
        }

        public Criteria andGotStatusEqualTo(Integer value) {
            addCriterion("got_status =", value, "gotStatus");
            return (Criteria) this;
        }

        public Criteria andGotStatusNotEqualTo(Integer value) {
            addCriterion("got_status <>", value, "gotStatus");
            return (Criteria) this;
        }

        public Criteria andGotStatusGreaterThan(Integer value) {
            addCriterion("got_status >", value, "gotStatus");
            return (Criteria) this;
        }

        public Criteria andGotStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("got_status >=", value, "gotStatus");
            return (Criteria) this;
        }

        public Criteria andGotStatusLessThan(Integer value) {
            addCriterion("got_status <", value, "gotStatus");
            return (Criteria) this;
        }

        public Criteria andGotStatusLessThanOrEqualTo(Integer value) {
            addCriterion("got_status <=", value, "gotStatus");
            return (Criteria) this;
        }

        public Criteria andGotStatusIn(List<Integer> values) {
            addCriterion("got_status in", values, "gotStatus");
            return (Criteria) this;
        }

        public Criteria andGotStatusNotIn(List<Integer> values) {
            addCriterion("got_status not in", values, "gotStatus");
            return (Criteria) this;
        }

        public Criteria andGotStatusBetween(Integer value1, Integer value2) {
            addCriterion("got_status between", value1, value2, "gotStatus");
            return (Criteria) this;
        }

        public Criteria andGotStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("got_status not between", value1, value2, "gotStatus");
            return (Criteria) this;
        }

        public Criteria andSmsStatusIsNull() {
            addCriterion("sms_status is null");
            return (Criteria) this;
        }

        public Criteria andSmsStatusIsNotNull() {
            addCriterion("sms_status is not null");
            return (Criteria) this;
        }

        public Criteria andSmsStatusEqualTo(Integer value) {
            addCriterion("sms_status =", value, "smsStatus");
            return (Criteria) this;
        }

        public Criteria andSmsStatusNotEqualTo(Integer value) {
            addCriterion("sms_status <>", value, "smsStatus");
            return (Criteria) this;
        }

        public Criteria andSmsStatusGreaterThan(Integer value) {
            addCriterion("sms_status >", value, "smsStatus");
            return (Criteria) this;
        }

        public Criteria andSmsStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("sms_status >=", value, "smsStatus");
            return (Criteria) this;
        }

        public Criteria andSmsStatusLessThan(Integer value) {
            addCriterion("sms_status <", value, "smsStatus");
            return (Criteria) this;
        }

        public Criteria andSmsStatusLessThanOrEqualTo(Integer value) {
            addCriterion("sms_status <=", value, "smsStatus");
            return (Criteria) this;
        }

        public Criteria andSmsStatusIn(List<Integer> values) {
            addCriterion("sms_status in", values, "smsStatus");
            return (Criteria) this;
        }

        public Criteria andSmsStatusNotIn(List<Integer> values) {
            addCriterion("sms_status not in", values, "smsStatus");
            return (Criteria) this;
        }

        public Criteria andSmsStatusBetween(Integer value1, Integer value2) {
            addCriterion("sms_status between", value1, value2, "smsStatus");
            return (Criteria) this;
        }

        public Criteria andSmsStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("sms_status not between", value1, value2, "smsStatus");
            return (Criteria) this;
        }

        public Criteria andDistTimeIsNull() {
            addCriterion("dist_time is null");
            return (Criteria) this;
        }

        public Criteria andDistTimeIsNotNull() {
            addCriterion("dist_time is not null");
            return (Criteria) this;
        }

        public Criteria andDistTimeEqualTo(String value) {
            addCriterion("dist_time =", value, "distTime");
            return (Criteria) this;
        }

        public Criteria andDistTimeNotEqualTo(String value) {
            addCriterion("dist_time <>", value, "distTime");
            return (Criteria) this;
        }

        public Criteria andDistTimeGreaterThan(String value) {
            addCriterion("dist_time >", value, "distTime");
            return (Criteria) this;
        }

        public Criteria andDistTimeGreaterThanOrEqualTo(String value) {
            addCriterion("dist_time >=", value, "distTime");
            return (Criteria) this;
        }

        public Criteria andDistTimeLessThan(String value) {
            addCriterion("dist_time <", value, "distTime");
            return (Criteria) this;
        }

        public Criteria andDistTimeLessThanOrEqualTo(String value) {
            addCriterion("dist_time <=", value, "distTime");
            return (Criteria) this;
        }

        public Criteria andDistTimeLike(String value) {
            addCriterion("dist_time like", value, "distTime");
            return (Criteria) this;
        }

        public Criteria andDistTimeNotLike(String value) {
            addCriterion("dist_time not like", value, "distTime");
            return (Criteria) this;
        }

        public Criteria andDistTimeIn(List<String> values) {
            addCriterion("dist_time in", values, "distTime");
            return (Criteria) this;
        }

        public Criteria andDistTimeNotIn(List<String> values) {
            addCriterion("dist_time not in", values, "distTime");
            return (Criteria) this;
        }

        public Criteria andDistTimeBetween(String value1, String value2) {
            addCriterion("dist_time between", value1, value2, "distTime");
            return (Criteria) this;
        }

        public Criteria andDistTimeNotBetween(String value1, String value2) {
            addCriterion("dist_time not between", value1, value2, "distTime");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingIsNull() {
            addCriterion("production_scheduling is null");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingIsNotNull() {
            addCriterion("production_scheduling is not null");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingEqualTo(Integer value) {
            addCriterion("production_scheduling =", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingNotEqualTo(Integer value) {
            addCriterion("production_scheduling <>", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingGreaterThan(Integer value) {
            addCriterion("production_scheduling >", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingGreaterThanOrEqualTo(Integer value) {
            addCriterion("production_scheduling >=", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingLessThan(Integer value) {
            addCriterion("production_scheduling <", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingLessThanOrEqualTo(Integer value) {
            addCriterion("production_scheduling <=", value, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingIn(List<Integer> values) {
            addCriterion("production_scheduling in", values, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingNotIn(List<Integer> values) {
            addCriterion("production_scheduling not in", values, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingBetween(Integer value1, Integer value2) {
            addCriterion("production_scheduling between", value1, value2, "productionScheduling");
            return (Criteria) this;
        }

        public Criteria andProductionSchedulingNotBetween(Integer value1, Integer value2) {
            addCriterion("production_scheduling not between", value1, value2, "productionScheduling");
            return (Criteria) this;
        }
    }

    /**
     * order_distribute
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    /**
     * @title order_distribute表的实体类
     * @description order_distribute
     * @version 1.0
     * @author yaokan
     * @date 2021-01-08 18:00:48
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}
